How to: Create a field for OLE objects.
Solution:
In the Table Design view, insert the field, and type a name for the field. Then select 'OLE Object' from the drop-down list in the 'Data Type' column.
NOTE: OLE objects such as pictures, documents, sound, and data from other binary fields can be stored in a table in an OLE field. The OLE objects can be linked or embedded in the field, and a control must be used to display the object on a Form or Report.
1) If the Database window is not active, activate the Database window.
2) Open an object in design view.
3) To insert a field, click in the next blank row.
4) Type a name for the field in the 'Field Name' column.
5) Click in the 'Data Type' column. (A down arrow appears.)
6) Click on the arrow in the 'Data Type' column. (A drop-down list appears.)
7) Select 'OLE Object' from the drop-down list.
Data type
8) Move to the 'Field Properties' section.
Field Properties section
9) Click the 'General' tab.
10) (Optional) Type a caption for the OLE object in the 'Caption' property box.
11) (Optional) Select either 'Yes' or 'No' from the 'Required' drop-down list box.
12) Select the 'File' menu and select 'Save' to save changes.
13) Select the 'File' menu and select 'Close' to close the Table Design view.
